package com.shangqing.system.droughtinformation.mapper;

import com.shangqing.system.droughtinformation.entity.DroughtGrade;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DroughtGradeMapper {
    @Select("select * from drought_grade")
    List<DroughtGrade> getinfo();

    @Select("select * from drought_grade where id=#{disastergradeid}")
    DroughtGrade getinfoById(int id);

    @Select("select * from drought_grade where id=#{droughtGradeid}")
    DroughtGrade getinfoBydroughtGradeid(int droughtGradeid);
}
